When ranking groups manually, you must enter criteria for each ranking group.
Note: When defining your manual rankings, you should use higher numbers for more desirable rankings and lower numbers for less desirable rankings to conform to industry standards for RFM rankings.
Example: Manually ranking RFM values
Recency
The criteria for ranking Recency is based on the last time the individual had contact with the organization. The date used is based on the Transaction Date specified in the Transaction Query. The following example illustrates how Recency is ranked:
■ Group 1: >10 days and <=15 days, value = 15
■ Group 2: >5 days and <=10 days, value = 10
■ Group 3: <=5 days
Frequency
The criteria for ranking Frequency is based on the number of times the individual had contact with the organization. The value is calculated by the number of records for an individual in the Transaction Query. The following example illustrates how Frequency is ranked:
■ Group 1: <20 times and >=0 times, value = 0
■ Group 2: <30 times and >=20 times, value = 20
■ Group 3: <50 times and >=30 times, value = 30
■ Group 4: >=50 times, value = 50
Monetary
The criteria for ranking Monetary is based on the amount of money the individual has spent with the organization. The amount is based on the total amount from the Transaction Query. The following example illustrates how Monetary is ranked:
■ Group 1: <0 and >=50, value = 50
■ Group 2: <50 and >=100, value = 100
■ Group 3: <100 and >=200, value = 200
■ Group 4: >200 and >=500, value = 500